﻿CREATE TABLE [dbo].[ShipFormDetail] (
    [ShipFormNo]   VARCHAR (30)    NOT NULL,
    [LineNo]       VARCHAR (3)     NULL,
    [ProductNo]    VARCHAR (10)    NULL,
    [ProductName]  VARCHAR (120)   NOT NULL,
    [ProductSpec]  VARCHAR (60)    NULL,
    [ProductModel] VARCHAR (60)    NULL,
    [Unit]         VARCHAR (20)    NOT NULL,
    [Qty]          NUMERIC (10, 2) NOT NULL,
    [Price]        NUMERIC (10, 2) NULL,
    [Amount]       NUMERIC (15, 2) NULL,
    [Remark]       VARCHAR (60)    NULL,
    [RecordId]     INT             IDENTITY (1, 1) NOT NULL
);

